youtube
🚀 Use Postgres for Free:
pg_textsearch was just open sourced. It enables BM25 to search your database.... massive upgrade for keyword search.
Google uses BM25 in their search engine. Now you can too.
Claude told me: "if you're already on Postgres, you can now skip the whole sync-your-data-to-Elasticsearch dance for search."
(ps, how can you not love Claude).
This video is all about implementing your own pg_textsearch _and_ vector search for powerful hybrid searches.
🆇 pg_textsearch went viral:
✅ Blog post:
🖥️ Code:
🖥️ pg_textsearch:
00:00:00 Welcome
00:01:00 Search Engine Bot with Python, Postgres & pg_textsearch
00:04:08 AI Agent to Build a Command Line Tool with Python
00:16:04 Storing Basic Data
00:20:32 Web Scraping to Markdown
00:25:56 Scraping with a Web Browser
00:35:53 Adding New Features
00:38:40 Fixing Code Errors with Claude
00:39:35 Create a Claude Project
00:42:08 Get Interviewed by AI Agents
00:46:02 Tracking File Changes with GitHub
00:49:44 Start building from AI Agent Interview Spec
00:54:02 Postgres on Tiger Data Cloud with pg_textsearch
01:01:42 Postgres MCP with pg-aiguide
01:13:44 Add Links, Crawl and Search
01:25:07 Vector Search
01:33:16 Hybrid Search
01:43:04 Adding a Web App
01:51:39 Reviewing the UI
01:58:12 Creating a Search Engine MCP
02:04:58 Modify CLI to run the MCP Server
02:10:49 Using the MCP Server in LLMs
02:18:41 Using our MCP in Claude Desktop
02:22:10 Thank you
|
2026/01/31
youtube
